package a_02_wizhi.M_mysql;

/**
 * @author fanhb on 2017/8/25
 * @desc mysql 定位文件
 */
public class Mysql_connection_etc_ {


    /**
     *
     * http://www.cnblogs.com/musings/p/5930338.html
     * https://zhidao.baidu.com/question/2140613377123462988.html
     *
     * SELECT @@global.tx_isolation;
     SELECT @@session.tx_isolation;
     SELECT @@tx_isolation;

     show full processlist

     show variables like '%max_connections%';
     show variables;

     查看行锁情况;
     show status like  '%row_lock%';

     只查看当前连接数(Threads就是连接数.):
     ./mysqladmin  -uadmin -p -h[ip] status

     show status like  'Threads_connected';

     set atuocommit=0; 设置自动提交为手动提交;
     mysql新特性: 没有索引的话, 行锁变表锁
     *
     */
}





